package test;

import com.itheima.utils.POIUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;

public class excele {
    @Test
    public void test01() throws Exception {
        XSSFWorkbook workbook = new XSSFWorkbook("E:\\hello.xlsx");
        XSSFSheet sheet = workbook.getSheetAt(0);
        for (Row row : sheet) {
            for (Cell cell : row) {
                System.out.println(cell);
            }
        }
    }

    @Test
    public void test02() {
        String s="03a36073-a140-4942-9b9b-712cecb144901.jpg";
        int i = s.lastIndexOf(".");
        String substring = s.substring(i);
        System.out.println(substring);

    }






}
